import sqlalchemy

from sqlalchemy import create_engine
from sqlalchemy.orm.exc import MultipleResultsFound, NoResultFound
from base import User, session, Base, engine
from relationship import Address


for u, a in session.query(User, Address).filter(User.id==Address.user_id).\
    filter(Address.email_address=='jack@google.com').all():
    print(u)
    print(a)
